﻿CREATE TABLE [dbo].[Guests] (
    [GuestId]        INT            IDENTITY (1, 1) NOT NULL,
    [Surname]        NVARCHAR (256) NOT NULL,
    [Name]           NVARCHAR (256) NOT NULL,
    [DateOfBirth]    DATETIME       NOT NULL,
    [CF]             NVARCHAR (16)  NOT NULL,
    [PI]             NVARCHAR (20)  NULL,
    [ForeignCity]    NVARCHAR (256) NULL,
    [Notes]          NVARCHAR (MAX) NULL,
    [Mail]           NVARCHAR (256) NULL,
    [BirthCountryId] INT            NOT NULL,
    [GenderId]       INT            NOT NULL,
    [PhoneNumber]    NVARCHAR (20)  NULL,
    [CompanyId]      INT            NULL,
    [BirthCityId]    INT            NULL
);





